<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10">
				<modelPath>/content/folder[@name='Packages']/package[@name='Chargeback']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:1500px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Capacity Changes and Growth</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Beginning Used Capacity (12 Months ago)</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="Summary">
			<contents><textItem><dataSource><dataItemValue refDataItem="Overall Begin Used (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Current Used Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton2" refQuery="Summary">
			<contents><textItem><dataSource><dataItemValue refDataItem="Overall Current Used (TB)"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Overall Change Differential</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton3" refQuery="Summary">
			<contents><textItem><dataSource><dataItemValue refDataItem="Differential"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="'+'###,###.##' TB'" whenNegative="'-'###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Overall Growth Rate (Monthly - Last 12 Months)</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton4" refQuery="Summary">
			<contents><textItem><dataSource><dataItemValue refDataItem="Overall Growth Rate"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="'+'###,###.##' TB'" whenNegative="'-'###,###.##' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage Inventory</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Growth Differential per Month)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px;padding-bottom:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<crosstab horizontalPagination="true" name="Crosstab1" refQuery="Report" rowsPerPage="5000">
			<crosstabCorner>
				<contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell colSpan="3"><contents><textItem><dataSource><staticValue>Storage Inventory</staticValue></dataSource><style><CSS value="color:white"/></style></textItem></contents><style><CSS value="text-align:left;font-size:20pt;color:gray"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="xm"/>
					</defaultStyles>
				<CSS value="vertical-align:middle;font-weight:bold;color:gray;font-size:14pt;text-align:left"/></style>
			</crosstabCorner>
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="xt"/>
				</defaultStyles>
			</style>
		<crosstabFactCell><contents><textItem><dataSource><cellValue/></dataSource><style><CSS value="color:#454545"/></style></textItem></contents><style><defaultStyles><defaultStyle refStyle="mv"/></defaultStyles></style></crosstabFactCell><crosstabRows><crosstabNode><crosstabNodeMembers><crosstabSpacer edgeLocation="s4">
			<contents>
				<textItem>
					<dataSource>
						<staticValue> </staticValue>
					</dataSource>
				</textItem>
			<textItem><dataSource><staticValue>Storage Name</staticValue></dataSource><style><CSS value="color:#7C7C7C;font-weight:bold"/></style></textItem></contents>
			
			<style>
				<defaultStyles>
					<defaultStyle refStyle="xs"/>
				</defaultStyles>
			</style>
		</crosstabSpacer></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e1" refDataItem="Storage Name"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="background-color:white;color:black;font-weight:bold"/></style><contents><textItem><dataSource><memberCaption/></dataSource><style><CSS value="color:#7C7C7C"/></style></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabRows><crosstabColumns><crosstabNode><crosstabNestedNodes><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e4" refDataItem="Beginning Used (TB)"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="font-weight:bold;color:rgb(227,228,227)"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabNestedNodes><crosstabNodeMembers><crosstabSpacer edgeLocation="s2">
			<contents>
				<textItem>
					<dataSource>
						<staticValue> </staticValue>
					</dataSource>
				</textItem>
			<textItem><dataSource><staticValue>Begin Used (TB)</staticValue></dataSource><style><CSS value="color:#7C7C7C"/></style></textItem></contents>
			
			<style>
				<defaultStyles>
					<defaultStyle refStyle="xs"/>
				</defaultStyles>
			<CSS value="color:black;font-weight:bold"/></style>
		</crosstabSpacer></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNestedNodes><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e5" refDataItem="Current Used (TB)"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="font-weight:bold;color:rgb(227,228,227)"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabNestedNodes><crosstabNodeMembers><crosstabSpacer edgeLocation="s1">
			<contents>
				<textItem>
					<dataSource>
						<staticValue> </staticValue>
					</dataSource>
				</textItem>
			<textItem><dataSource><staticValue>Current Used (TB)</staticValue></dataSource><style><CSS value="color:#7C7C7C"/></style></textItem></contents>
			
			<style>
				<defaultStyles>
					<defaultStyle refStyle="xs"/>
				</defaultStyles>
			<CSS value="color:black;font-weight:bold"/></style>
		</crosstabSpacer></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNestedNodes><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e2" refDataItem="Diff +/-"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="color:black;font-weight:bold"/></style><contents><textItem><dataSource><memberCaption/></dataSource><style><CSS value="color:#7C7C7C"/></style></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabNestedNodes><crosstabNodeMembers><crosstabNodeMember edgeLocation="e3" refDataItem="Full Date"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><dataFormat><dateFormat showDays="false" showMonths="shortName" showYears="true"/></dataFormat><CSS value="color:black;font-weight:bold"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource><style><CSS value="color:#7C7C7C"/></style></textItem></contents><sortList><sortItem refDataItem="Full Date"/></sortList></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabColumns><crosstabIntersections><crosstabIntersection column="e4" row="e1"><style><CSS value="background-color:white;color:#454545;border:1pt solid silver"/></style></crosstabIntersection><crosstabIntersection column="e5" row="e1"><style><CSS value="background-color:white;color:#454545;border:1pt solid silver"/></style></crosstabIntersection><crosstabIntersection column="e2" row="e1"><style><CSS value="background-color:white;color:#454545;border:1pt solid silver"/><dataFormat><format pattern="####.##" whenAnyError="0" whenMissing="0" whenNotApplicable="0" whenSecurityError="0"/></dataFormat></style><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 2"/></conditionalStyleRefs></crosstabIntersection><crosstabIntersection row="s4" column="e4"><style><CSS value="background-color:#F7F7F7"/></style></crosstabIntersection><crosstabIntersection row="s4" column="e5"><style><CSS value="background-color:#F7F7F7"/></style></crosstabIntersection><crosstabIntersection row="s4" column="e2"><style><CSS value="background-color:#F7F7F7"/></style></crosstabIntersection></crosstabIntersections></crosstab></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage Growth Rates</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Last 12 Months)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px;padding-bottom:3px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="0" maxHotspots="10000" name="Combination Chart9" orientation="horizontal" refQuery="Report">
														<v2_combinationTypeTooltips/>
														<v2_legend>
															<style>
																<defaultStyles>
																	<defaultStyle refStyle="lg"/>
																</defaultStyles>
															</style>
															<v2_legendPosition><v2_legendPreset legendPositionPreset="bottom"/></v2_legendPosition></v2_legend>
														<v2_commonAxis>
															<v2_ordinalAxis>
																<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/></style>
																</v2_axisLabels>
															</v2_ordinalAxis>
															<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Storage Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Average Growth Rate"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
														<v2_topLeftAxis>
															<v2_combinationChartTypes>
																<v2_bar barShape="box" bevel="none" setOrdinalWidthScale="80" borders="show" borderColor="white">
																	
																	<v2_solidPalette>
                                                                                                <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#839862"><v2_solidColor color="#26A9E0" transparency="0"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#1E4A93" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#0077BF" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#B7C873"><v2_solidColor color="#66BECB" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#8484A8"><v2_solidColor color="#8484A8" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C0CCED">
                                                            <v2_linearGradient>
                                                                <v2_gradientColor gradientColor="#C0CCED"/>
                                                                <v2_gradientColor colorPosition="100" gradientColor="#B0C2E5"/>
                                                            </v2_linearGradient>
                                                        </v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#8C5580">
                                                            <v2_linearGradient>
                                                                <v2_gradientColor gradientColor="#8C5580"/>
                                                                <v2_gradientColor colorPosition="100" gradientColor="#794067"/>
                                                            </v2_linearGradient>
                                                        </v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C789BC">
                                                            <v2_linearGradient>
                                                                <v2_gradientColor gradientColor="#C789BC"/>
                                                                <v2_gradientColor colorPosition="100" gradientColor="#BB72BC"/>
                                                            </v2_linearGradient>
                                                        </v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#D5BAEF">
                                                            <v2_linearGradient>
                                                                <v2_gradientColor gradientColor="#D5BAEF"/>
                                                                <v2_gradientColor colorPosition="100" gradientColor="#C29FD1"/>
                                                            </v2_linearGradient>
                                                        </v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#83683F">
                                                            <v2_linearGradient>
                                                                <v2_gradientColor gradientColor="#83683F"/>
                                                                <v2_gradientColor colorPosition="100" gradientColor="#604926"/>
                                                            </v2_linearGradient>
                                                        </v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#DCB05A">
                                                            <v2_linearGradient>
                                                                <v2_gradientColor gradientColor="#DCB05A"/>
                                                                <v2_gradientColor colorPosition="100" gradientColor="#C09C52"/>
                                                            </v2_linearGradient>
                                                        </v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F4DF9E">
                                                            <v2_linearGradient>
                                                                <v2_gradientColor gradientColor="#F4DF9E"/>
                                                                <v2_gradientColor colorPosition="100" gradientColor="#E4CF87"/>
                                                            </v2_linearGradient>
                                                        </v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#5F8A8C">
                                                            <v2_linearGradient>
                                                                <v2_gradientColor gradientColor="#5F8A8C"/>
                                                                <v2_gradientColor colorPosition="100" gradientColor="#537579"/>
                                                            </v2_linearGradient>
                                                        </v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#96C4B2">
                                                            <v2_linearGradient>
                                                                <v2_gradientColor gradientColor="#96C4B2"/>
                                                                <v2_gradientColor colorPosition="100" gradientColor="#89B0A0"/>
                                                            </v2_linearGradient>
                                                        </v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CBE8E7">
                                                            <v2_linearGradient>
                                                                <v2_gradientColor gradientColor="#CBE8E7"/>
                                                                <v2_gradientColor colorPosition="100" gradientColor="#BDD6D5"/>
                                                            </v2_linearGradient>
                                                        </v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#AE6564">
                                                            <v2_linearGradient>
                                                                <v2_gradientColor gradientColor="#AE6564"/>
                                                                <v2_gradientColor colorPosition="100" gradientColor="#875352"/>
                                                            </v2_linearGradient>
                                                        </v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#D88C6F">
                                                            <v2_linearGradient>
                                                                <v2_gradientColor gradientColor="#D88C6F"/>
                                                                <v2_gradientColor colorPosition="100" gradientColor="#C47D61"/>
                                                            </v2_linearGradient>
                                                        </v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3C9B0">
                                                            <v2_linearGradient>
                                                                <v2_gradientColor gradientColor="#E3C9B0"/>
                                                                <v2_gradientColor colorPosition="100" gradientColor="#D2B2A5"/>
                                                            </v2_linearGradient>
                                                        </v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#848484">
                                                            <v2_linearGradient>
                                                                <v2_gradientColor gradientColor="#848484"/>
                                                                <v2_gradientColor colorPosition="100" gradientColor="#555555"/>
                                                            </v2_linearGradient>
                                                        </v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#a4a4a4">
                                                            <v2_linearGradient>
                                                                <v2_gradientColor gradientColor="#a4a4a4"/>
                                                                <v2_gradientColor colorPosition="100" gradientColor="#909090"/>
                                                            </v2_linearGradient>
                                                        </v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C7C7C7">
                                                            <v2_linearGradient>
                                                                <v2_gradientColor gradientColor="#C7C7C7"/>
                                                                <v2_gradientColor colorPosition="100" gradientColor="#c1c1c1"/>
                                                            </v2_linearGradient>
                                                        </v2_fillEffect></v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Average Growth Rate"><chartContents><chartTextItem><dataSource><staticValue/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat decimalSize="2"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_conditionalSolidPalette showInLegend="show"><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><reportCondition>[Report].[Average Growth Rate]&lt;0</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor transparency="10" color="#FFB2C1"/></v2_fillEffect></v2_solidPaletteEntry><v2_conditionalPaletteEntryLabel><v2_specifiedLabel><defaultText>Negative Growth</defaultText></v2_specifiedLabel></v2_conditionalPaletteEntryLabel></v2_conditionalCase><v2_conditionalCase><reportCondition>[Report].[Average Growth Rate]&gt;0</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#9AD7CD" transparency="5"/></v2_fillEffect></v2_solidPaletteEntry><v2_conditionalPaletteEntryLabel><v2_specifiedLabel><defaultText>Positive Growth</defaultText></v2_specifiedLabel></v2_conditionalPaletteEntryLabel></v2_conditionalCase></v2_conditionalCases></v2_advancedCondition></v2_conditionalSolidPalette><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" labelValueType="absolute" leaderLines="hide"/></v2_bar>
															</v2_combinationChartTypes>
															<v2_axis>
																<v2_axisRange>
																	<v2_automaticRange/>
																</v2_axisRange>
																<v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                                <dataFormat><numberFormat decimalSize="0"/></dataFormat><CSS value="color:#454545"/></style>
                                                                                        </v2_axisLabels></v2_axis>
														</v2_topLeftAxis>
														<style>
															<CSS value="width:350px;font-family:Arial;height:600px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
														<noDataHandler>
															<contents>
																<block>
																	<contents>
																		<textItem>
																			<dataSource>
																				<staticValue>No Data Available</staticValue>
																			</dataSource>
																			<style>
																				<CSS value="padding:10px 18px;"/>
																			</style>
																		</textItem>
																	</contents>
																</block>
															</contents>
														</noDataHandler>
														<chartSuppress divByZero="true" nulls="true" overflow="true" type="categoriesAndSeries" zero="true"/></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px 10px 10px 10px;height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.905Z"/></XMLAttributes><reportName>2.23 Capacity Changes and Growth</reportName><queries><query name="Base Capacity Trends">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL1">
			<sqlText>SELECT
trend.storage as 'Storage Name',
trend.datacenter as 'Data Center',
trend.model as 'Model',
trend.fulldate as 'Full Date',
trend.capacityTB as 'Usable (TB)',
trend.usedCapacityTB as 'Used (TB)',
begin.capacityTB as 'Beginning Usable (TB)',
begin.usedCapacityTB as 'Beginning Used (TB)',
end.capacityTB as 'Current Usable (TB)',
end.usedCapacityTB as 'Current Used (TB)'


FROM (

SELECT 	
	dwh_capacity.storage_dimension.datacenter as datacenter,
	dwh_capacity.storage_dimension.name as storage,
	dwh_capacity.storage_dimension.model as model,
	dwh_capacity.storage_dimension.tk as storagetk,
	dwh_capacity.date_dimension.fulldate as fulldate,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS rawCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS capacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS usedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS provisionedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS volumeConsumedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS internalVolumeAllocatedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS internalVolumeConsumedTB
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND	dwh_capacity.date_dimension.repmonthorlatest=1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY

GROUP BY
	dwh_capacity.storage_dimension.name, dwh_capacity.date_dimension.fulldate

) trend

LEFT JOIN

( SELECT 	
	dwh_capacity.storage_dimension.name as storage,
	dwh_capacity.storage_dimension.tk as storagetk,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS rawCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS capacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS usedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS provisionedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS volumeConsumedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS internalVolumeAllocatedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS internalVolumeConsumedTB,
	dwh_capacity.date_dimension.fulldate
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND	dwh_capacity.date_dimension.repmonthorlatest=1

WHERE dwh_capacity.date_dimension.fullDate BETWEEN 

(SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY 

AND

(SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 335 DAY 



GROUP BY
	dwh_capacity.storage_dimension.name

) begin ON begin.storagetk=trend.storagetk


LEFT JOIN

( SELECT 	
	dwh_capacity.storage_dimension.name as storage,
	dwh_capacity.storage_dimension.tk as storagetk,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS rawCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS capacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS usedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS provisionedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS volumeConsumedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS internalVolumeAllocatedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS internalVolumeConsumedTB
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND	dwh_capacity.date_dimension.repmonthorlatest=1

WHERE dwh_capacity.date_dimension.fullDate = (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY
	dwh_capacity.storage_dimension.name

) end ON end.storagetk=trend.storagetk


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Data Center"/><mdProjectedItem name="Model"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Usable (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Beginning Usable (TB)"/><mdProjectedItem name="Beginning Used (TB)"/><mdProjectedItem name="Current Usable (TB)"/><mdProjectedItem name="Current Used (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Data Center"><expression>[SQL1].[Data Center]</expression></dataItem><dataItem name="Storage Name" rollupAggregate="none"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Model"><expression>[SQL1].[Model]</expression></dataItem><dataItem name="Full Date"><expression>[SQL1].[Full Date]</expression></dataItem><dataItem name="Usable (TB)"><expression>[SQL1].[Usable (TB)]</expression></dataItem><dataItem aggregate="maximum" name="Used (TB)"><expression>[SQL1].[Used (TB)]</expression></dataItem><dataItem name="Beginning Usable (TB)"><expression>[SQL1].[Beginning Usable (TB)]</expression></dataItem><dataItem aggregate="maximum" name="Beginning Used (TB)"><expression>[SQL1].[Beginning Used (TB)]</expression></dataItem><dataItem name="Current Usable (TB)"><expression>[SQL1].[Current Usable (TB)]</expression></dataItem><dataItem aggregate="maximum" name="Current Used (TB)"><expression>[SQL1].[Current Used (TB)]</expression></dataItem><dataItem name="Diff +/-"><expression>if(running-difference([Used (TB)] for [Storage Name]) is null) THEN (0) ELSE (running-difference([Used (TB)] for [Storage Name]))</expression></dataItem><dataItem name="Average Growth Rate"><expression>([Current Used (TB)]-[Beginning Used (TB)])/12</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Storage Name]&lt;&gt;'N/A'</filterExpression></detailFilter></detailFilters></query><query name="Report">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL2">
			<sqlText>SELECT
trend.storage as 'Storage Name',
trend.model as 'Model',
trend.fulldate as 'Full Date',
trend.capacityTB as 'Usable (TB)',
trend.usedCapacityTB as 'Used (TB)',
IF(begin.capacityTB is null, 0, begin.capacityTB) as 'Beginning Usable (TB)',
IF(begin.usedCapacityTB is null, 0, begin.usedCapacityTB) as 'Beginning Used (TB)',
IF(end.capacityTB is null, 0, end.capacityTB) as 'Current Usable (TB)',
IF(end.usedCapacityTB is null, 0, end.usedCapacityTB ) as 'Current Used (TB)'


FROM (

SELECT 	
	IF(dwh_capacity.storage_dimension.manufacturer='netapp', SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',1), dwh_capacity.storage_dimension.name) as storage,
	

	dwh_capacity.storage_dimension.model as model,
	dwh_capacity.storage_dimension.tk as storagetk,
	dwh_capacity.date_dimension.fulldate as fulldate,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS rawCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS capacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS usedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS provisionedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS volumeConsumedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS internalVolumeAllocatedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS internalVolumeConsumedTB
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk

JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND	dwh_capacity.date_dimension.repmonthorlatest=1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY

GROUP BY
	storage, dwh_capacity.date_dimension.fulldate

) trend

LEFT JOIN

( SELECT 	
	IF(dwh_capacity.storage_dimension.manufacturer='netapp', SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',1), dwh_capacity.storage_dimension.name) as storage,
	
	dwh_capacity.storage_dimension.tk as storagetk,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS rawCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS capacityTB,
	ROUND(MAX(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS usedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS provisionedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS volumeConsumedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS internalVolumeAllocatedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS internalVolumeConsumedTB,
	dwh_capacity.date_dimension.fulldate
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk

JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND	dwh_capacity.date_dimension.repmonthorlatest=1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MIN(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension)
AND dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY

GROUP BY
	storage

) begin ON begin.storagetk=trend.storagetk


LEFT JOIN

( SELECT 	
IF(dwh_capacity.storage_dimension.manufacturer='netapp', SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',1), dwh_capacity.storage_dimension.name) as storage,
	dwh_capacity.storage_dimension.tk as storagetk,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS rawCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS capacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS usedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS provisionedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS volumeConsumedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS internalVolumeAllocatedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS internalVolumeConsumedTB
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk

JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND	dwh_capacity.date_dimension.repmonthorlatest=1

WHERE dwh_capacity.date_dimension.fullDate = (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY
	storage

) end ON end.storagetk=trend.storagetk


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Model"/><mdProjectedItem name="Full Date"/><mdProjectedItem name="Usable (TB)"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Beginning Usable (TB)"/><mdProjectedItem name="Beginning Used (TB)"/><mdProjectedItem name="Current Usable (TB)"/><mdProjectedItem name="Current Used (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL2].[Storage Name]</expression></dataItem><dataItem name="Model"><expression>[SQL2].[Model]</expression></dataItem><dataItem name="Full Date"><expression>[SQL2].[Full Date]</expression></dataItem><dataItem name="Usable (TB)"><expression>[SQL2].[Usable (TB)]</expression></dataItem><dataItem name="Used (TB)"><expression>[SQL2].[Used (TB)]</expression></dataItem><dataItem name="Beginning Usable (TB)"><expression>[SQL2].[Beginning Usable (TB)]</expression></dataItem><dataItem aggregate="maximum" name="Beginning Used (TB)"><expression>[SQL2].[Beginning Used (TB)]</expression></dataItem><dataItem name="Current Usable (TB)"><expression>[SQL2].[Current Usable (TB)]</expression></dataItem><dataItem aggregate="maximum" name="Current Used (TB)"><expression>[SQL2].[Current Used (TB)]</expression></dataItem><dataItem name="Diff +/-"><expression>if(running-difference([Used (TB)] for [Storage Name]) is null) THEN (0) ELSE (running-difference([Used (TB)] for [Storage Name]))</expression></dataItem><dataItem name="Average Growth Rate"><expression>([Current Used (TB)]-[Beginning Used (TB)])/12</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Storage Name]&lt;&gt;'N/A'</filterExpression></detailFilter></detailFilters></query><query name="Summary">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
sum(begin.usedCapacityTB) as 'Overall Begin Used (TB)',
(select ROUND(SUM(dwh_inventory.storage_pool.totalUsedCapacityMB)/1024/1024,2)
FROM dwh_inventory.storage
JOIN dwh_inventory.storage_pool ON dwh_inventory.storage_pool.storageid=dwh_inventory.storage.id
) as 'Overall Current Used (TB)'


FROM
(
SELECT 	
	IF(dwh_capacity.storage_dimension.manufacturer='netapp', SUBSTRING_INDEX(dwh_capacity.storage_pool_dimension.name,':',1), dwh_capacity.storage_dimension.name) as storage,
	
	dwh_capacity.storage_dimension.tk as storagetk,
	dwh_capacity.storage_dimension.id as storageid,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawcapacityMB)/1024/1024, 2) AS rawCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024/1024, 2) AS capacityTB,
	ROUND(MAX(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024/1024, 2) AS usedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024/1024, 2) AS provisionedCapacityTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeConsumedCapacityMB)/1024/1024, 2) AS volumeConsumedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB)/1024/1024, 2) AS internalVolumeAllocatedTB,
	ROUND(SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeConsumedCapacityMB)/1024/1024, 2) AS internalVolumeConsumedTB,
	dwh_capacity.date_dimension.fulldate
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.isVirtual = 0
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk

JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND	dwh_capacity.date_dimension.repmonthorlatest=1

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MIN(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension)
AND dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 365 DAY

GROUP BY
	storage ) begin


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Overall Begin Used (TB)"/><mdProjectedItem name="Overall Current Used (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Overall Begin Used (TB)"><expression>[SQL3].[Overall Begin Used (TB)]</expression></dataItem><dataItem name="Overall Current Used (TB)"><expression>[SQL3].[Overall Current Used (TB)]</expression></dataItem><dataItem name="Differential"><expression>[Overall Current Used (TB)]-[Overall Begin Used (TB)]</expression></dataItem><dataItem name="Overall Growth Rate"><expression>[Differential]/12</expression></dataItem></selection>
		</query></queries><namedConditionalStyles><advancedConditionalStyle name="Conditional Style 2"><styleCases><styleCase><style><CSS value="color:red"/></style><reportCondition>[Report].[Diff +/-]&lt;0</reportCondition></styleCase><styleCase><style><CSS value="color:green"/></style><reportCondition>[Report].[Diff +/-]&gt;0</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle></namedConditionalStyles></report>